﻿CREATE TABLE [dbo].[webpages_UsersInRoles] (
    [UserId]       INT NOT NULL,
    [RoleId]       INT NOT NULL,
    [UserInRoleId] INT NOT NULL   IDENTITY (1, 1),
    PRIMARY KEY CLUSTERED ([UserInRoleId] ASC),
    CONSTRAINT [fk_UserId] FOREIGN KEY ([UserId]) REFERENCES [dbo].[UserProfile] ([UserId]),
    CONSTRAINT [fk_RoleId] FOREIGN KEY ([RoleId]) REFERENCES [dbo].[webpages_Roles] ([RoleId])
);

